{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["LIQUIDACION","TABLA"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"LIQUIDACION","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[0,0,0,5],[3,0,3,5]]}
["LIQUIDADOR INTERESES DE MORA"]
[]
[]
["WWW.SISCONT.COM.CO"]
[]
[null,"FECHA ACTUAL",null,{"$f":"+TODAY()","v":"2016-11-10"}]
[]
[]
[null,"VALOR DEL IMPUESTO EN MORA"]
[]
[null,"FECHA DE VENCIMIENTO ",null,null,"Miércoles"]
[]
[null,"FECHA DEL PAGO",null,null,"Viernes"]
[]
[]
[null,"DIAS DE MORA",null,{"$f":"D13-D11","v":0}]
[]
[null,"VALOR IMPUESTO",null,{"$f":"D9","v":0}]
[]
[null,"VALOR INTERESES*",null,{"$f":"ROUND(SUM(TABLA!F3:F131),-3)","v":0}]
[]
[null,"TOTAL A PAGAR",null,{"$f":"SUM(D18:D20)","v":0}]
[]
[]
[]
[]
[null,"* VERIFIQUE QUE LA TASA DE INTERESES VIGENTE ESTÉ"]
[null,"   REGISTRADA CORRECTAMENTE EN LA TABLA."]

{"sheet":"TABLA","index":1,"n_rows":131,"n_cols":6,"rows_kept":131,"merged":[[4,0,9,0],[10,0,22,0],[23,0,34,0],[35,0,46,0],[47,0,58,0],[59,0,70,0],[71,0,82,0],[83,0,94,0],[95,0,106,0],[107,0,118,0],[119,0,130,0]]}
["AÑO","MES",null,"TASA","No. DIAS","VALOR"]
["% de Interés moratorio Antes de la Ley 1066"]
["Hasta Julio 28 de 2006",null,"2006-07-28",{"v":0.2063,"d":"20.63%"},{"$f":"IF(C3<LIQUIDACION!$D$11,0,IF(C3>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11),(C3-LIQUIDACION!$D$11)))","v":0},{"$f":"LIQUIDACION!$D$9*(D3/365*E3)","v":0}]
["% de Interés moratorio Después de la Ley 1066"]
[2006,"Julio","2006-07-31",{"v":0.2262,"d":"22.62%"},{"$f":"IF(C5<LIQUIDACION!$D$11,0,IF(C5>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E4)),(C5-LIQUIDACION!$D$11-SUM($E$3:E4))))","v":0},{"$f":"LIQUIDACION!$D$9*(((1+D5)^(1/365)^E5)-1)","v":0}]
[null,"Agosto","2006-08-31",{"v":0.2253,"d":"22.53%"},{"$f":"IF(C6<LIQUIDACION!$D$11,0,IF(C6>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E5)),(C6-LIQUIDACION!$D$11-SUM($E$3:E5))))","v":0},{"$f":"(LIQUIDACION!$D$9+SUM($F$5:F5))*(((1+D6)^(1/365)^E6)-1)","v":0}]
[null,"Septiembre","2006-09-30",{"v":0.2258,"d":"22.58%"},{"$f":"IF(C7<LIQUIDACION!$D$11,0,IF(C7>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E6)),(C7-LIQUIDACION!$D$11-SUM($E$3:E6))))","v":0},{"$f":"(LIQUIDACION!$D$9+SUM($F$5:F6))*(((1+D7)^(1/365)^E7)-1)","v":0}]
[null,"Octubre","2006-10-31",{"v":0.2261,"d":"22.61%"},{"$f":"IF(C8<LIQUIDACION!$D$11,0,IF(C8>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E7)),(C8-LIQUIDACION!$D$11-SUM($E$3:E7))))","v":0},{"$f":"(LIQUIDACION!$D$9+SUM($F$5:F7))*(((1+D8)^(1/365)^E8)-1)","v":0}]
[null,"Noviembre","2006-11-30",{"v":0.2261,"d":"22.61%"},{"$f":"IF(C9<LIQUIDACION!$D$11,0,IF(C9>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E8)),(C9-LIQUIDACION!$D$11-SUM($E$3:E8))))","v":0},{"$f":"(LIQUIDACION!$D$9+SUM($F$5:F8))*(((1+D9)^(1/365)^E9)-1)","v":0}]
[null,"Diciembre","2006-12-31",{"v":0.2261,"d":"22.61%"},{"$f":"IF(C10<LIQUIDACION!$D$11,0,IF(C10>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E9)),(C10-LIQUIDACION!$D$11-SUM($E$3:E9))))","v":0},{"$f":"(LIQUIDACION!$D$9+SUM($F$5:F9))*(((1+D10)^(1/365)^E10)-1)","v":0}]
[2007,"Enero","2007-01-31",{"v":0.3209,"d":"32.09%"},{"$f":"IF(C11<LIQUIDACION!$D$11,0,IF(C11>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E10)),(C11-LIQUIDACION!$D$11-SUM($E$3:E10))))","v":0},{"$f":"+IF(D11=\"\",0,ROUND(((LIQUIDACION!$D$9*(D11/366))*E11),-3))","v":0}]
[null,"Febrero","2007-02-25",{"v":0.3209,"d":"32.09%"},{"$f":"IF(C12<LIQUIDACION!$D$11,0,IF(C12>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E11)),(C12-LIQUIDACION!$D$11-SUM($E$3:E11))))","v":0},{"$f":"+IF(D12=\"\",0,ROUND(((LIQUIDACION!$D$9*(D12/366))*E12),-3))","v":0}]
[null,"Febrero","2007-02-28",{"v":0.2075,"d":"20.75%"},{"$f":"IF(C13<LIQUIDACION!$D$11,0,IF(C13>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E12)),(C13-LIQUIDACION!$D$11-SUM($E$3:E12))))","v":0},{"$f":"+IF(D13=\"\",0,ROUND(((LIQUIDACION!$D$9*(D13/366))*E13),-3))","v":0}]
[null,"Marzo","2007-03-31",{"v":0.2075,"d":"20.75%"},{"$f":"IF(C14<LIQUIDACION!$D$11,0,IF(C14>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E13)),(C14-LIQUIDACION!$D$11-SUM($E$3:E13))))","v":0},{"$f":"+IF(D14=\"\",0,ROUND(((LIQUIDACION!$D$9*(D14/366))*E14),-3))","v":0}]
[null,"Abril","2007-04-30",{"v":0.2513,"d":"25.13%"},{"$f":"IF(C15<LIQUIDACION!$D$11,0,IF(C15>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E14)),(C15-LIQUIDACION!$D$11-SUM($E$3:E14))))","v":0},{"$f":"+IF(D15=\"\",0,ROUND(((LIQUIDACION!$D$9*(D15/366))*E15),-3))","v":0}]
[null,"Mayo","2007-05-31",{"v":0.2513,"d":"25.13%"},{"$f":"IF(C16<LIQUIDACION!$D$11,0,IF(C16>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E15)),(C16-LIQUIDACION!$D$11-SUM($E$3:E15))))","v":0},{"$f":"+IF(D16=\"\",0,ROUND(((LIQUIDACION!$D$9*(D16/366))*E16),-3))","v":0}]
[null,"Junio","2007-06-30",{"v":0.2513,"d":"25.13%"},{"$f":"IF(C17<LIQUIDACION!$D$11,0,IF(C17>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E16)),(C17-LIQUIDACION!$D$11-SUM($E$3:E16))))","v":0},{"$f":"+IF(D17=\"\",0,ROUND(((LIQUIDACION!$D$9*(D17/366))*E17),-3))","v":0}]
[null,"Julio","2007-07-31",{"v":0.2851,"d":"28.51%"},{"$f":"IF(C18<LIQUIDACION!$D$11,0,IF(C18>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E17)),(C18-LIQUIDACION!$D$11-SUM($E$3:E17))))","v":0},{"$f":"+IF(D18=\"\",0,ROUND(((LIQUIDACION!$D$9*(D18/366))*E18),-3))","v":0}]
[null,"Agosto","2007-08-31",{"v":0.2851,"d":"28.51%"},{"$f":"IF(C19<LIQUIDACION!$D$11,0,IF(C19>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E18)),(C19-LIQUIDACION!$D$11-SUM($E$3:E18))))","v":0},{"$f":"+IF(D19=\"\",0,ROUND(((LIQUIDACION!$D$9*(D19/366))*E19),-3))","v":0}]
[null,"Septiembre","2007-09-30",{"v":0.2851,"d":"28.51%"},{"$f":"IF(C20<LIQUIDACION!$D$11,0,IF(C20>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E19)),(C20-LIQUIDACION!$D$11-SUM($E$3:E19))))","v":0},{"$f":"+IF(D20=\"\",0,ROUND(((LIQUIDACION!$D$9*(D20/366))*E20),-3))","v":0}]
[null,"Octubre","2007-10-31",{"v":0.3189,"d":"31.89%"},{"$f":"IF(C21<LIQUIDACION!$D$11,0,IF(C21>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E20)),(C21-LIQUIDACION!$D$11-SUM($E$3:E20))))","v":0},{"$f":"+IF(D21=\"\",0,ROUND(((LIQUIDACION!$D$9*(D21/366))*E21),-3))","v":0}]
[null,"Noviembre","2007-11-30",{"v":0.3189,"d":"31.89%"},{"$f":"IF(C22<LIQUIDACION!$D$11,0,IF(C22>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E21)),(C22-LIQUIDACION!$D$11-SUM($E$3:E21))))","v":0},{"$f":"+IF(D22=\"\",0,ROUND(((LIQUIDACION!$D$9*(D22/366))*E22),-3))","v":0}]
[null,"Diciembre","2007-12-31",{"v":0.3189,"d":"31.89%"},{"$f":"IF(C23<LIQUIDACION!$D$11,0,IF(C23>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E22)),(C23-LIQUIDACION!$D$11-SUM($E$3:E22))))","v":0},{"$f":"+IF(D23=\"\",0,ROUND(((LIQUIDACION!$D$9*(D23/366))*E23),-3))","v":0}]
[2008,"Enero","2008-01-31",{"v":0.3275,"d":"32.75%"},{"$f":"IF(C24<LIQUIDACION!$D$11,0,IF(C24>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E23)),(C24-LIQUIDACION!$D$11-SUM($E$3:E23))))","v":0},{"$f":"+IF(D24=\"\",0,ROUND(((LIQUIDACION!$D$9*(D24/366))*E24),-3))","v":0}]
[null,"Febrero","2008-02-29",{"v":0.3275,"d":"32.75%"},{"$f":"IF(C25<LIQUIDACION!$D$11,0,IF(C25>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E24)),(C25-LIQUIDACION!$D$11-SUM($E$3:E24))))","v":0},{"$f":"+IF(D25=\"\",0,ROUND(((LIQUIDACION!$D$9*(D25/366))*E25),-3))","v":0}]
[null,"Marzo","2008-03-31",{"v":0.3275,"d":"32.75%"},{"$f":"IF(C26<LIQUIDACION!$D$11,0,IF(C26>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E25)),(C26-LIQUIDACION!$D$11-SUM($E$3:E25))))","v":0},{"$f":"+IF(D26=\"\",0,ROUND(((LIQUIDACION!$D$9*(D26/366))*E26),-3))","v":0}]
[null,"Abril","2008-04-30",{"v":0.3288,"d":"32.88%"},{"$f":"IF(C27<LIQUIDACION!$D$11,0,IF(C27>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E26)),(C27-LIQUIDACION!$D$11-SUM($E$3:E26))))","v":0},{"$f":"+IF(D27=\"\",0,ROUND(((LIQUIDACION!$D$9*(D27/366))*E27),-3))","v":0}]
[null,"Mayo","2008-05-31",{"v":0.3288,"d":"32.88%"},{"$f":"IF(C28<LIQUIDACION!$D$11,0,IF(C28>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E27)),(C28-LIQUIDACION!$D$11-SUM($E$3:E27))))","v":0},{"$f":"+IF(D28=\"\",0,ROUND(((LIQUIDACION!$D$9*(D28/366))*E28),-3))","v":0}]
[null,"Junio","2008-06-30",{"v":0.3288,"d":"32.88%"},{"$f":"IF(C29<LIQUIDACION!$D$11,0,IF(C29>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E28)),(C29-LIQUIDACION!$D$11-SUM($E$3:E28))))","v":0},{"$f":"+IF(D29=\"\",0,ROUND(((LIQUIDACION!$D$9*(D29/366))*E29),-3))","v":0}]
[null,"Julio","2008-07-31",{"v":0.3227,"d":"32.27%"},{"$f":"IF(C30<LIQUIDACION!$D$11,0,IF(C30>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E29)),(C30-LIQUIDACION!$D$11-SUM($E$3:E29))))","v":0},{"$f":"+IF(D30=\"\",0,ROUND(((LIQUIDACION!$D$9*(D30/366))*E30),-3))","v":0}]
[null,"Agosto","2008-08-31",{"v":0.3227,"d":"32.27%"},{"$f":"IF(C31<LIQUIDACION!$D$11,0,IF(C31>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E30)),(C31-LIQUIDACION!$D$11-SUM($E$3:E30))))","v":0},{"$f":"+IF(D31=\"\",0,ROUND(((LIQUIDACION!$D$9*(D31/366))*E31),-3))","v":0}]
[null,"Septiembre","2008-09-30",{"v":0.3227,"d":"32.27%"},{"$f":"IF(C32<LIQUIDACION!$D$11,0,IF(C32>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E31)),(C32-LIQUIDACION!$D$11-SUM($E$3:E31))))","v":0},{"$f":"+IF(D32=\"\",0,ROUND(((LIQUIDACION!$D$9*(D32/366))*E32),-3))","v":0}]
[null,"Octubre","2008-10-31",{"v":0.3153,"d":"31.53%"},{"$f":"IF(C33<LIQUIDACION!$D$11,0,IF(C33>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E32)),(C33-LIQUIDACION!$D$11-SUM($E$3:E32))))","v":0},{"$f":"+IF(D33=\"\",0,ROUND(((LIQUIDACION!$D$9*(D33/366))*E33),-3))","v":0}]
[null,"Noviembre","2008-11-30",{"v":0.3153,"d":"31.53%"},{"$f":"IF(C34<LIQUIDACION!$D$11,0,IF(C34>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E33)),(C34-LIQUIDACION!$D$11-SUM($E$3:E33))))","v":0},{"$f":"+IF(D34=\"\",0,ROUND(((LIQUIDACION!$D$9*(D34/366))*E34),-3))","v":0}]
[null,"Diciembre","2008-12-31",{"v":0.3153,"d":"31.53%"},{"$f":"IF(C35<LIQUIDACION!$D$11,0,IF(C35>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E34)),(C35-LIQUIDACION!$D$11-SUM($E$3:E34))))","v":0},{"$f":"+IF(D35=\"\",0,ROUND(((LIQUIDACION!$D$9*(D35/366))*E35),-3))","v":0}]
[2009,"Enero","2009-01-31",{"v":0.3071,"d":"30.71%"},{"$f":"IF(C36<LIQUIDACION!$D$11,0,IF(C36>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E35)),(C36-LIQUIDACION!$D$11-SUM($E$3:E35))))","v":0},{"$f":"+IF(D36=\"\",0,ROUND(((LIQUIDACION!$D$9*(D36/366))*E36),-3))","v":0}]
[null,"Febrero","2009-02-28",{"v":0.3071,"d":"30.71%"},{"$f":"IF(C37<LIQUIDACION!$D$11,0,IF(C37>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E36)),(C37-LIQUIDACION!$D$11-SUM($E$3:E36))))","v":0},{"$f":"+IF(D37=\"\",0,ROUND(((LIQUIDACION!$D$9*(D37/366))*E37),-3))","v":0}]
[null,"Marzo","2009-03-31",{"v":0.3071,"d":"30.71%"},{"$f":"IF(C38<LIQUIDACION!$D$11,0,IF(C38>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E37)),(C38-LIQUIDACION!$D$11-SUM($E$3:E37))))","v":0},{"$f":"+IF(D38=\"\",0,ROUND(((LIQUIDACION!$D$9*(D38/366))*E38),-3))","v":0}]
[null,"Abril","2009-04-30",{"v":0.3042,"d":"30.42%"},{"$f":"IF(C39<LIQUIDACION!$D$11,0,IF(C39>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E38)),(C39-LIQUIDACION!$D$11-SUM($E$3:E38))))","v":0},{"$f":"+IF(D39=\"\",0,ROUND(((LIQUIDACION!$D$9*(D39/366))*E39),-3))","v":0}]
[null,"Mayo","2009-05-31",{"v":0.3042,"d":"30.42%"},{"$f":"IF(C40<LIQUIDACION!$D$11,0,IF(C40>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E39)),(C40-LIQUIDACION!$D$11-SUM($E$3:E39))))","v":0},{"$f":"+IF(D40=\"\",0,ROUND(((LIQUIDACION!$D$9*(D40/366))*E40),-3))","v":0}]
[null,"Junio","2009-06-30",{"v":0.3042,"d":"30.42%"},{"$f":"IF(C41<LIQUIDACION!$D$11,0,IF(C41>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E40)),(C41-LIQUIDACION!$D$11-SUM($E$3:E40))))","v":0},{"$f":"+IF(D41=\"\",0,ROUND(((LIQUIDACION!$D$9*(D41/366))*E41),-3))","v":0}]
[null,"Julio","2009-07-31",{"v":0.2798,"d":"27.98%"},{"$f":"IF(C42<LIQUIDACION!$D$11,0,IF(C42>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E41)),(C42-LIQUIDACION!$D$11-SUM($E$3:E41))))","v":0},{"$f":"+IF(D42=\"\",0,ROUND(((LIQUIDACION!$D$9*(D42/366))*E42),-3))","v":0}]
[null,"Agosto","2009-08-31",{"v":0.2798,"d":"27.98%"},{"$f":"IF(C43<LIQUIDACION!$D$11,0,IF(C43>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E42)),(C43-LIQUIDACION!$D$11-SUM($E$3:E42))))","v":0},{"$f":"+IF(D43=\"\",0,ROUND(((LIQUIDACION!$D$9*(D43/366))*E43),-3))","v":0}]
[null,"Septiembre","2009-09-30",{"v":0.2798,"d":"27.98%"},{"$f":"IF(C44<LIQUIDACION!$D$11,0,IF(C44>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E43)),(C44-LIQUIDACION!$D$11-SUM($E$3:E43))))","v":0},{"$f":"+IF(D44=\"\",0,ROUND(((LIQUIDACION!$D$9*(D44/366))*E44),-3))","v":0}]
[null,"Octubre","2009-10-31",{"v":0.2592,"d":"25.92%"},{"$f":"IF(C45<LIQUIDACION!$D$11,0,IF(C45>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E44)),(C45-LIQUIDACION!$D$11-SUM($E$3:E44))))","v":0},{"$f":"+IF(D45=\"\",0,ROUND(((LIQUIDACION!$D$9*(D45/366))*E45),-3))","v":0}]
[null,"Noviembre","2009-11-30",{"v":0.2592,"d":"25.92%"},{"$f":"IF(C46<LIQUIDACION!$D$11,0,IF(C46>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E45)),(C46-LIQUIDACION!$D$11-SUM($E$3:E45))))","v":0},{"$f":"+IF(D46=\"\",0,ROUND(((LIQUIDACION!$D$9*(D46/366))*E46),-3))","v":0}]
[null,"Diciembre","2009-12-31",{"v":0.2592,"d":"25.92%"},{"$f":"IF(C47<LIQUIDACION!$D$11,0,IF(C47>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E46)),(C47-LIQUIDACION!$D$11-SUM($E$3:E46))))","v":0},{"$f":"+IF(D47=\"\",0,ROUND(((LIQUIDACION!$D$9*(D47/366))*E47),-3))","v":0}]
[2010,"Enero","2010-01-31",{"v":0.2421,"d":"24.21%"},{"$f":"IF(C48<LIQUIDACION!$D$11,0,IF(C48>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E47)),(C48-LIQUIDACION!$D$11-SUM($E$3:E47))))","v":0},{"$f":"+IF(D48=\"\",0,ROUND(((LIQUIDACION!$D$9*(D48/366))*E48),-3))","v":0}]
[null,"Febrero","2010-02-28",{"v":0.2421,"d":"24.21%"},{"$f":"IF(C49<LIQUIDACION!$D$11,0,IF(C49>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E48)),(C49-LIQUIDACION!$D$11-SUM($E$3:E48))))","v":0},{"$f":"+IF(D49=\"\",0,ROUND(((LIQUIDACION!$D$9*(D49/366))*E49),-3))","v":0}]
[null,"Marzo","2010-03-31",{"v":0.2421,"d":"24.21%"},{"$f":"IF(C50<LIQUIDACION!$D$11,0,IF(C50>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E49)),(C50-LIQUIDACION!$D$11-SUM($E$3:E49))))","v":0},{"$f":"+IF(D50=\"\",0,ROUND(((LIQUIDACION!$D$9*(D50/366))*E50),-3))","v":0}]
[null,"Abril","2010-04-30",{"v":0.2297,"d":"22.97%"},{"$f":"IF(C51<LIQUIDACION!$D$11,0,IF(C51>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E50)),(C51-LIQUIDACION!$D$11-SUM($E$3:E50))))","v":0},{"$f":"+IF(D51=\"\",0,ROUND(((LIQUIDACION!$D$9*(D51/366))*E51),-3))","v":0}]
[null,"Mayo","2010-05-31",{"v":0.2297,"d":"22.97%"},{"$f":"IF(C52<LIQUIDACION!$D$11,0,IF(C52>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E51)),(C52-LIQUIDACION!$D$11-SUM($E$3:E51))))","v":0},{"$f":"+IF(D52=\"\",0,ROUND(((LIQUIDACION!$D$9*(D52/366))*E52),-3))","v":0}]
[null,"Junio","2010-06-30",{"v":0.2297,"d":"22.97%"},{"$f":"IF(C53<LIQUIDACION!$D$11,0,IF(C53>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E52)),(C53-LIQUIDACION!$D$11-SUM($E$3:E52))))","v":0},{"$f":"+IF(D53=\"\",0,ROUND(((LIQUIDACION!$D$9*(D53/366))*E53),-3))","v":0}]
[null,"Julio","2010-07-31",{"v":0.2241,"d":"22.41%"},{"$f":"IF(C54<LIQUIDACION!$D$11,0,IF(C54>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E53)),(C54-LIQUIDACION!$D$11-SUM($E$3:E53))))","v":0},{"$f":"+IF(D54=\"\",0,ROUND(((LIQUIDACION!$D$9*(D54/366))*E54),-3))","v":0}]
[null,"Agosto","2010-08-31",{"v":0.2241,"d":"22.41%"},{"$f":"IF(C55<LIQUIDACION!$D$11,0,IF(C55>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E54)),(C55-LIQUIDACION!$D$11-SUM($E$3:E54))))","v":0},{"$f":"+IF(D55=\"\",0,ROUND(((LIQUIDACION!$D$9*(D55/366))*E55),-3))","v":0}]
[null,"Septiembre","2010-09-30",{"v":0.2241,"d":"22.41%"},{"$f":"IF(C56<LIQUIDACION!$D$11,0,IF(C56>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E55)),(C56-LIQUIDACION!$D$11-SUM($E$3:E55))))","v":0},{"$f":"+IF(D56=\"\",0,ROUND(((LIQUIDACION!$D$9*(D56/366))*E56),-3))","v":0}]
[null,"Octubre","2010-10-31",{"v":0.2132,"d":"21.32%"},{"$f":"IF(C57<LIQUIDACION!$D$11,0,IF(C57>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E56)),(C57-LIQUIDACION!$D$11-SUM($E$3:E56))))","v":0},{"$f":"+IF(D57=\"\",0,ROUND(((LIQUIDACION!$D$9*(D57/366))*E57),-3))","v":0}]
[null,"Noviembre","2010-11-30",{"v":0.2132,"d":"21.32%"},{"$f":"IF(C58<LIQUIDACION!$D$11,0,IF(C58>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E57)),(C58-LIQUIDACION!$D$11-SUM($E$3:E57))))","v":0},{"$f":"+IF(D58=\"\",0,ROUND(((LIQUIDACION!$D$9*(D58/366))*E58),-3))","v":0}]
[null,"Diciembre","2010-12-31",{"v":0.2132,"d":"21.32%"},{"$f":"IF(C59<LIQUIDACION!$D$11,0,IF(C59>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E58)),(C59-LIQUIDACION!$D$11-SUM($E$3:E58))))","v":0},{"$f":"+IF(D59=\"\",0,ROUND(((LIQUIDACION!$D$9*(D59/366))*E59),-3))","v":0}]
[2011,"Enero","2011-01-31",{"v":0.2342,"d":"23.42%"},{"$f":"IF(C60<LIQUIDACION!$D$11,0,IF(C60>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E59)),(C60-LIQUIDACION!$D$11-SUM($E$3:E59))))","v":0},{"$f":"+IF(D60=\"\",0,ROUND(((LIQUIDACION!$D$9*(D60/366))*E60),-3))","v":0}]
[null,"Febrero","2011-02-28",{"v":0.2342,"d":"23.42%"},{"$f":"IF(C61<LIQUIDACION!$D$11,0,IF(C61>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E60)),(C61-LIQUIDACION!$D$11-SUM($E$3:E60))))","v":0},{"$f":"+IF(D61=\"\",0,ROUND(((LIQUIDACION!$D$9*(D61/366))*E61),-3))","v":0}]
[null,"Marzo","2011-03-31",{"v":0.2342,"d":"23.42%"},{"$f":"IF(C62<LIQUIDACION!$D$11,0,IF(C62>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E61)),(C62-LIQUIDACION!$D$11-SUM($E$3:E61))))","v":0},{"$f":"+IF(D62=\"\",0,ROUND(((LIQUIDACION!$D$9*(D62/366))*E62),-3))","v":0}]
[null,"Abril","2011-04-30",{"v":0.2654,"d":"26.54%"},{"$f":"IF(C63<LIQUIDACION!$D$11,0,IF(C63>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E62)),(C63-LIQUIDACION!$D$11-SUM($E$3:E62))))","v":0},{"$f":"+IF(D63=\"\",0,ROUND(((LIQUIDACION!$D$9*(D63/366))*E63),-3))","v":0}]
[null,"Mayo","2011-05-31",{"v":0.2654,"d":"26.54%"},{"$f":"IF(C64<LIQUIDACION!$D$11,0,IF(C64>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E63)),(C64-LIQUIDACION!$D$11-SUM($E$3:E63))))","v":0},{"$f":"+IF(D64=\"\",0,ROUND(((LIQUIDACION!$D$9*(D64/366))*E64),-3))","v":0}]
[null,"Junio","2011-06-30",{"v":0.2654,"d":"26.54%"},{"$f":"IF(C65<LIQUIDACION!$D$11,0,IF(C65>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E64)),(C65-LIQUIDACION!$D$11-SUM($E$3:E64))))","v":0},{"$f":"+IF(D65=\"\",0,ROUND(((LIQUIDACION!$D$9*(D65/366))*E65),-3))","v":0}]
[null,"Julio","2011-07-31",{"v":0.2795,"d":"27.95%"},{"$f":"IF(C66<LIQUIDACION!$D$11,0,IF(C66>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E65)),(C66-LIQUIDACION!$D$11-SUM($E$3:E65))))","v":0},{"$f":"+IF(D66=\"\",0,ROUND(((LIQUIDACION!$D$9*(D66/366))*E66),-3))","v":0}]
[null,"Agosto","2011-08-31",{"v":0.2795,"d":"27.95%"},{"$f":"IF(C67<LIQUIDACION!$D$11,0,IF(C67>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E66)),(C67-LIQUIDACION!$D$11-SUM($E$3:E66))))","v":0},{"$f":"+IF(D67=\"\",0,ROUND(((LIQUIDACION!$D$9*(D67/366))*E67),-3))","v":0}]
[null,"Septiembre","2011-09-30",{"v":0.2795,"d":"27.95%"},{"$f":"IF(C68<LIQUIDACION!$D$11,0,IF(C68>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E67)),(C68-LIQUIDACION!$D$11-SUM($E$3:E67))))","v":0},{"$f":"+IF(D68=\"\",0,ROUND(((LIQUIDACION!$D$9*(D68/366))*E68),-3))","v":0}]
[null,"Octubre","2011-10-31",{"v":0.2909,"d":"29.09%"},{"$f":"IF(C69<LIQUIDACION!$D$11,0,IF(C69>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E68)),(C69-LIQUIDACION!$D$11-SUM($E$3:E68))))","v":0},{"$f":"+IF(D69=\"\",0,ROUND(((LIQUIDACION!$D$9*(D69/366))*E69),-3))","v":0}]
[null,"Noviembre","2011-11-30",{"v":0.2909,"d":"29.09%"},{"$f":"IF(C70<LIQUIDACION!$D$11,0,IF(C70>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E69)),(C70-LIQUIDACION!$D$11-SUM($E$3:E69))))","v":0},{"$f":"+IF(D70=\"\",0,ROUND(((LIQUIDACION!$D$9*(D70/366))*E70),-3))","v":0}]
[null,"Diciembre","2011-12-31",{"v":0.2909,"d":"29.09%"},{"$f":"IF(C71<LIQUIDACION!$D$11,0,IF(C71>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E70)),(C71-LIQUIDACION!$D$11-SUM($E$3:E70))))","v":0},{"$f":"+IF(D71=\"\",0,ROUND(((LIQUIDACION!$D$9*(D71/366))*E71),-3))","v":0}]
[2012,"Enero","2012-01-31",{"v":0.2988,"d":"29.88%"},{"$f":"IF(C72<LIQUIDACION!$D$11,0,IF(C72>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E71)),(C72-LIQUIDACION!$D$11-SUM($E$3:E71))))","v":0},{"$f":"+IF(D72=\"\",0,ROUND(((LIQUIDACION!$D$9*(D72/366))*E72),-3))","v":0}]
[null,"Febrero","2012-02-29",{"v":0.2988,"d":"29.88%"},{"$f":"IF(C73<LIQUIDACION!$D$11,0,IF(C73>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E72)),(C73-LIQUIDACION!$D$11-SUM($E$3:E72))))","v":0},{"$f":"+IF(D73=\"\",0,ROUND(((LIQUIDACION!$D$9*(D73/366))*E73),-3))","v":0}]
[null,"Marzo","2012-03-31",{"v":0.2988,"d":"29.88%"},{"$f":"IF(C74<LIQUIDACION!$D$11,0,IF(C74>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E73)),(C74-LIQUIDACION!$D$11-SUM($E$3:E73))))","v":0},{"$f":"+IF(D74=\"\",0,ROUND(((LIQUIDACION!$D$9*(D74/366))*E74),-3))","v":0}]
[null,"Abril","2012-04-30",{"v":0.3078,"d":"30.78%"},{"$f":"IF(C75<LIQUIDACION!$D$11,0,IF(C75>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E74)),(C75-LIQUIDACION!$D$11-SUM($E$3:E74))))","v":0},{"$f":"+IF(D75=\"\",0,ROUND(((LIQUIDACION!$D$9*(D75/366))*E75),-3))","v":0}]
[null,"Mayo","2012-05-31",{"v":0.3078,"d":"30.78%"},{"$f":"IF(C76<LIQUIDACION!$D$11,0,IF(C76>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E75)),(C76-LIQUIDACION!$D$11-SUM($E$3:E75))))","v":0},{"$f":"+IF(D76=\"\",0,ROUND(((LIQUIDACION!$D$9*(D76/366))*E76),-3))","v":0}]
[null,"Junio","2012-06-30",{"v":0.3078,"d":"30.78%"},{"$f":"IF(C77<LIQUIDACION!$D$11,0,IF(C77>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E76)),(C77-LIQUIDACION!$D$11-SUM($E$3:E76))))","v":0},{"$f":"+IF(D77=\"\",0,ROUND(((LIQUIDACION!$D$9*(D77/366))*E77),-3))","v":0}]
[null,"Julio","2012-07-31",{"v":0.3129,"d":"31.29%"},{"$f":"IF(C78<LIQUIDACION!$D$11,0,IF(C78>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E77)),(C78-LIQUIDACION!$D$11-SUM($E$3:E77))))","v":0},{"$f":"+IF(D78=\"\",0,ROUND(((LIQUIDACION!$D$9*(D78/366))*E78),-3))","v":0}]
[null,"Agosto","2012-08-31",{"v":0.3129,"d":"31.29%"},{"$f":"IF(C79<LIQUIDACION!$D$11,0,IF(C79>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E78)),(C79-LIQUIDACION!$D$11-SUM($E$3:E78))))","v":0},{"$f":"+IF(D79=\"\",0,ROUND(((LIQUIDACION!$D$9*(D79/366))*E79),-3))","v":0}]
[null,"Septiembre","2012-09-30",{"v":0.3129,"d":"31.29%"},{"$f":"IF(C80<LIQUIDACION!$D$11,0,IF(C80>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E79)),(C80-LIQUIDACION!$D$11-SUM($E$3:E79))))","v":0},{"$f":"+IF(D80=\"\",0,ROUND(((LIQUIDACION!$D$9*(D80/366))*E80),-3))","v":0}]
[null,"Octubre","2012-10-31",{"v":0.3134,"d":"31.34%"},{"$f":"IF(C81<LIQUIDACION!$D$11,0,IF(C81>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E80)),(C81-LIQUIDACION!$D$11-SUM($E$3:E80))))","v":0},{"$f":"+IF(D81=\"\",0,ROUND(((LIQUIDACION!$D$9*(D81/366))*E81),-3))","v":0}]
[null,"Noviembre","2012-11-30",{"v":0.3134,"d":"31.34%"},{"$f":"IF(C82<LIQUIDACION!$D$11,0,IF(C82>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E81)),(C82-LIQUIDACION!$D$11-SUM($E$3:E81))))","v":0},{"$f":"+IF(D82=\"\",0,ROUND(((LIQUIDACION!$D$9*(D82/366))*E82),-3))","v":0}]
[null,"Diciembre","2012-12-31",{"v":0.3134,"d":"31.34%"},{"$f":"IF(C83<LIQUIDACION!$D$11,0,IF(C83>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E82)),(C83-LIQUIDACION!$D$11-SUM($E$3:E82))))","v":0},{"$f":"+IF(D83=\"\",0,ROUND(((LIQUIDACION!$D$9*(D83/366))*E83),-3))","v":0}]
[2013,"Enero","2013-01-31",{"v":0.3113,"d":"31.13%"},{"$f":"IF(C84<LIQUIDACION!$D$11,0,IF(C84>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E83)),(C84-LIQUIDACION!$D$11-SUM($E$3:E83))))","v":0},{"$f":"+IF(D84=\"\",0,ROUND(((LIQUIDACION!$D$9*(D84/366))*E84),-3))","v":0}]
[null,"Febrero","2013-02-28",{"v":0.3113,"d":"31.13%"},{"$f":"IF(C85<LIQUIDACION!$D$11,0,IF(C85>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E84)),(C85-LIQUIDACION!$D$11-SUM($E$3:E84))))","v":0},{"$f":"+IF(D85=\"\",0,ROUND(((LIQUIDACION!$D$9*(D85/366))*E85),-3))","v":0}]
[null,"Marzo","2013-03-31",{"v":0.3113,"d":"31.13%"},{"$f":"IF(C86<LIQUIDACION!$D$11,0,IF(C86>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E85)),(C86-LIQUIDACION!$D$11-SUM($E$3:E85))))","v":0},{"$f":"+IF(D86=\"\",0,ROUND(((LIQUIDACION!$D$9*(D86/366))*E86),-3))","v":0}]
[null,"Abril","2013-04-30",{"v":0.3125,"d":"31.25%"},{"$f":"IF(C87<LIQUIDACION!$D$11,0,IF(C87>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E86)),(C87-LIQUIDACION!$D$11-SUM($E$3:E86))))","v":0},{"$f":"+IF(D87=\"\",0,ROUND(((LIQUIDACION!$D$9*(D87/366))*E87),-3))","v":0}]
[null,"Mayo","2013-05-31",{"v":0.3125,"d":"31.25%"},{"$f":"IF(C88<LIQUIDACION!$D$11,0,IF(C88>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E87)),(C88-LIQUIDACION!$D$11-SUM($E$3:E87))))","v":0},{"$f":"+IF(D88=\"\",0,ROUND(((LIQUIDACION!$D$9*(D88/366))*E88),-3))","v":0}]
[null,"Junio","2013-06-30",{"v":0.3125,"d":"31.25%"},{"$f":"IF(C89<LIQUIDACION!$D$11,0,IF(C89>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E88)),(C89-LIQUIDACION!$D$11-SUM($E$3:E88))))","v":0},{"$f":"+IF(D89=\"\",0,ROUND(((LIQUIDACION!$D$9*(D89/366))*E89),-3))","v":0}]
[null,"Julio","2013-07-31",{"v":0.3051,"d":"30.51%"},{"$f":"IF(C90<LIQUIDACION!$D$11,0,IF(C90>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E89)),(C90-LIQUIDACION!$D$11-SUM($E$3:E89))))","v":0},{"$f":"+IF(D90=\"\",0,ROUND(((LIQUIDACION!$D$9*(D90/366))*E90),-3))","v":0}]
[null,"Agosto","2013-08-31",{"v":0.3051,"d":"30.51%"},{"$f":"IF(C91<LIQUIDACION!$D$11,0,IF(C91>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E90)),(C91-LIQUIDACION!$D$11-SUM($E$3:E90))))","v":0},{"$f":"+IF(D91=\"\",0,ROUND(((LIQUIDACION!$D$9*(D91/366))*E91),-3))","v":0}]
[null,"Septiembre","2013-09-30",{"v":0.3051,"d":"30.51%"},{"$f":"IF(C92<LIQUIDACION!$D$11,0,IF(C92>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E91)),(C92-LIQUIDACION!$D$11-SUM($E$3:E91))))","v":0},{"$f":"+IF(D92=\"\",0,ROUND(((LIQUIDACION!$D$9*(D92/366))*E92),-3))","v":0}]
[null,"Octubre","2013-10-31",{"v":0.2978,"d":"29.78%"},{"$f":"IF(C93<LIQUIDACION!$D$11,0,IF(C93>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E92)),(C93-LIQUIDACION!$D$11-SUM($E$3:E92))))","v":0},{"$f":"+IF(D93=\"\",0,ROUND(((LIQUIDACION!$D$9*(D93/366))*E93),-3))","v":0}]
[null,"Noviembre","2013-11-30",{"v":0.2978,"d":"29.78%"},{"$f":"IF(C94<LIQUIDACION!$D$11,0,IF(C94>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E93)),(C94-LIQUIDACION!$D$11-SUM($E$3:E93))))","v":0},{"$f":"+IF(D94=\"\",0,ROUND(((LIQUIDACION!$D$9*(D94/366))*E94),-3))","v":0}]
[null,"Diciembre","2013-12-31",{"v":0.2978,"d":"29.78%"},{"$f":"IF(C95<LIQUIDACION!$D$11,0,IF(C95>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E94)),(C95-LIQUIDACION!$D$11-SUM($E$3:E94))))","v":0},{"$f":"+IF(D95=\"\",0,ROUND(((LIQUIDACION!$D$9*(D95/366))*E95),-3))","v":0}]
[2014,"Enero","2014-01-31",{"v":0.2948,"d":"29.48%"},{"$f":"IF(C96<LIQUIDACION!$D$11,0,IF(C96>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E95)),(C96-LIQUIDACION!$D$11-SUM($E$3:E95))))","v":0},{"$f":"+IF(D96=\"\",0,ROUND(((LIQUIDACION!$D$9*(D96/366))*E96),-3))","v":0}]
[null,"Febrero","2014-02-28",{"v":0.2948,"d":"29.48%"},{"$f":"IF(C97<LIQUIDACION!$D$11,0,IF(C97>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E96)),(C97-LIQUIDACION!$D$11-SUM($E$3:E96))))","v":0},{"$f":"+IF(D97=\"\",0,ROUND(((LIQUIDACION!$D$9*(D97/366))*E97),-3))","v":0}]
[null,"Marzo","2014-03-31",{"v":0.2948,"d":"29.48%"},{"$f":"IF(C98<LIQUIDACION!$D$11,0,IF(C98>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E97)),(C98-LIQUIDACION!$D$11-SUM($E$3:E97))))","v":0},{"$f":"+IF(D98=\"\",0,ROUND(((LIQUIDACION!$D$9*(D98/366))*E98),-3))","v":0}]
[null,"Abril","2014-04-30",{"v":0.2945,"d":"29.45%"},{"$f":"IF(C99<LIQUIDACION!$D$11,0,IF(C99>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E98)),(C99-LIQUIDACION!$D$11-SUM($E$3:E98))))","v":0},{"$f":"+IF(D99=\"\",0,ROUND(((LIQUIDACION!$D$9*(D99/366))*E99),-3))","v":0}]
[null,"Mayo","2014-05-31",{"v":0.2945,"d":"29.45%"},{"$f":"IF(C100<LIQUIDACION!$D$11,0,IF(C100>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E99)),(C100-LIQUIDACION!$D$11-SUM($E$3:E99))))","v":0},{"$f":"+IF(D100=\"\",0,ROUND(((LIQUIDACION!$D$9*(D100/366))*E100),-3))","v":0}]
[null,"Junio","2014-06-30",{"v":0.2945,"d":"29.45%"},{"$f":"IF(C101<LIQUIDACION!$D$11,0,IF(C101>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E100)),(C101-LIQUIDACION!$D$11-SUM($E$3:E100))))","v":0},{"$f":"+IF(D101=\"\",0,ROUND(((LIQUIDACION!$D$9*(D101/366))*E101),-3))","v":0}]
[null,"Julio","2014-07-31",{"v":0.29,"d":"29.00%"},{"$f":"IF(C102<LIQUIDACION!$D$11,0,IF(C102>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E101)),(C102-LIQUIDACION!$D$11-SUM($E$3:E101))))","v":0},{"$f":"+IF(D102=\"\",0,ROUND(((LIQUIDACION!$D$9*(D102/366))*E102),-3))","v":0}]
[null,"Agosto","2014-08-31",{"v":0.29,"d":"29.00%"},{"$f":"IF(C103<LIQUIDACION!$D$11,0,IF(C103>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E102)),(C103-LIQUIDACION!$D$11-SUM($E$3:E102))))","v":0},{"$f":"+IF(D103=\"\",0,ROUND(((LIQUIDACION!$D$9*(D103/366))*E103),-3))","v":0}]
[null,"Septiembre","2014-09-30",{"v":0.29,"d":"29.00%"},{"$f":"IF(C104<LIQUIDACION!$D$11,0,IF(C104>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E103)),(C104-LIQUIDACION!$D$11-SUM($E$3:E103))))","v":0},{"$f":"+IF(D104=\"\",0,ROUND(((LIQUIDACION!$D$9*(D104/366))*E104),-3))","v":0}]
[null,"Octubre","2014-10-31",{"v":0.2876,"d":"28.76%"},{"$f":"IF(C105<LIQUIDACION!$D$11,0,IF(C105>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E104)),(C105-LIQUIDACION!$D$11-SUM($E$3:E104))))","v":0},{"$f":"+IF(D105=\"\",0,ROUND(((LIQUIDACION!$D$9*(D105/366))*E105),-3))","v":0}]
[null,"Noviembre","2014-11-30",{"v":0.2876,"d":"28.76%"},{"$f":"IF(C106<LIQUIDACION!$D$11,0,IF(C106>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E105)),(C106-LIQUIDACION!$D$11-SUM($E$3:E105))))","v":0},{"$f":"+IF(D106=\"\",0,ROUND(((LIQUIDACION!$D$9*(D106/366))*E106),-3))","v":0}]
[null,"Diciembre","2014-12-31",{"v":0.2876,"d":"28.76%"},{"$f":"IF(C107<LIQUIDACION!$D$11,0,IF(C107>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E106)),(C107-LIQUIDACION!$D$11-SUM($E$3:E106))))","v":0},{"$f":"+IF(D107=\"\",0,ROUND(((LIQUIDACION!$D$9*(D107/366))*E107),-3))","v":0}]
[2015,"Enero","2015-01-31",{"v":0.2882,"d":"28.82%"},{"$f":"IF(C108<LIQUIDACION!$D$11,0,IF(C108>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E107)),(C108-LIQUIDACION!$D$11-SUM($E$3:E107))))","v":0},{"$f":"+IF(D108=\"\",0,ROUND(((LIQUIDACION!$D$9*(D108/366))*E108),-3))","v":0}]
[null,"Febrero","2015-02-28",{"v":0.2882,"d":"28.82%"},{"$f":"IF(C109<LIQUIDACION!$D$11,0,IF(C109>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E108)),(C109-LIQUIDACION!$D$11-SUM($E$3:E108))))","v":0},{"$f":"+IF(D109=\"\",0,ROUND(((LIQUIDACION!$D$9*(D109/366))*E109),-3))","v":0}]
[null,"Marzo","2015-03-31",{"v":0.2882,"d":"28.82%"},{"$f":"IF(C110<LIQUIDACION!$D$11,0,IF(C110>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E109)),(C110-LIQUIDACION!$D$11-SUM($E$3:E109))))","v":0},{"$f":"+IF(D110=\"\",0,ROUND(((LIQUIDACION!$D$9*(D110/366))*E110),-3))","v":0}]
[null,"Abril","2015-04-30",{"v":0.2906,"d":"29.06%"},{"$f":"IF(C111<LIQUIDACION!$D$11,0,IF(C111>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E110)),(C111-LIQUIDACION!$D$11-SUM($E$3:E110))))","v":0},{"$f":"+IF(D111=\"\",0,ROUND(((LIQUIDACION!$D$9*(D111/366))*E111),-3))","v":0}]
[null,"Mayo","2015-05-31",{"v":0.2906,"d":"29.06%"},{"$f":"IF(C112<LIQUIDACION!$D$11,0,IF(C112>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E111)),(C112-LIQUIDACION!$D$11-SUM($E$3:E111))))","v":0},{"$f":"+IF(D112=\"\",0,ROUND(((LIQUIDACION!$D$9*(D112/366))*E112),-3))","v":0}]
[null,"Junio","2015-06-30",{"v":0.2906,"d":"29.06%"},{"$f":"IF(C113<LIQUIDACION!$D$11,0,IF(C113>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E112)),(C113-LIQUIDACION!$D$11-SUM($E$3:E112))))","v":0},{"$f":"+IF(D113=\"\",0,ROUND(((LIQUIDACION!$D$9*(D113/366))*E113),-3))","v":0}]
[null,"Julio","2015-07-31",{"v":0.2889,"d":"28.89%"},{"$f":"IF(C114<LIQUIDACION!$D$11,0,IF(C114>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E113)),(C114-LIQUIDACION!$D$11-SUM($E$3:E113))))","v":0},{"$f":"+IF(D114=\"\",0,ROUND(((LIQUIDACION!$D$9*(D114/366))*E114),-3))","v":0}]
[null,"Agosto","2015-08-31",{"v":0.2889,"d":"28.89%"},{"$f":"IF(C115<LIQUIDACION!$D$11,0,IF(C115>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E114)),(C115-LIQUIDACION!$D$11-SUM($E$3:E114))))","v":0},{"$f":"+IF(D115=\"\",0,ROUND(((LIQUIDACION!$D$9*(D115/366))*E115),-3))","v":0}]
[null,"Septiembre","2015-09-30",{"v":0.2889,"d":"28.89%"},{"$f":"IF(C116<LIQUIDACION!$D$11,0,IF(C116>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E115)),(C116-LIQUIDACION!$D$11-SUM($E$3:E115))))","v":0},{"$f":"+IF(D116=\"\",0,ROUND(((LIQUIDACION!$D$9*(D116/366))*E116),-3))","v":0}]
[null,"Octubre","2015-10-31",{"v":0.29,"d":"29.00%"},{"$f":"IF(C117<LIQUIDACION!$D$11,0,IF(C117>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E116)),(C117-LIQUIDACION!$D$11-SUM($E$3:E116))))","v":0},{"$f":"+IF(D117=\"\",0,ROUND(((LIQUIDACION!$D$9*(D117/366))*E117),-3))","v":0}]
[null,"Noviembre","2015-11-30",{"v":0.29,"d":"29.00%"},{"$f":"IF(C118<LIQUIDACION!$D$11,0,IF(C118>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E117)),(C118-LIQUIDACION!$D$11-SUM($E$3:E117))))","v":0},{"$f":"+IF(D118=\"\",0,ROUND(((LIQUIDACION!$D$9*(D118/366))*E118),-3))","v":0}]
[null,"Diciembre","2015-12-31",{"v":0.29,"d":"29.00%"},{"$f":"IF(C119<LIQUIDACION!$D$11,0,IF(C119>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E118)),(C119-LIQUIDACION!$D$11-SUM($E$3:E118))))","v":0},{"$f":"+IF(D119=\"\",0,ROUND(((LIQUIDACION!$D$9*(D119/366))*E119),-3))","v":0}]
[2016,"Enero","2016-01-31",{"v":0.2952,"d":"29.52%"},{"$f":"IF(C120<LIQUIDACION!$D$11,0,IF(C120>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E119)),(C120-LIQUIDACION!$D$11-SUM($E$3:E119))))","v":0},{"$f":"+IF(D120=\"\",0,ROUND(((LIQUIDACION!$D$9*(D120/366))*E120),-3))","v":0}]
[null,"Febrero","2016-02-29",{"v":0.2952,"d":"29.52%"},{"$f":"IF(C121<LIQUIDACION!$D$11,0,IF(C121>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E120)),(C121-LIQUIDACION!$D$11-SUM($E$3:E120))))","v":0},{"$f":"+IF(D121=\"\",0,ROUND(((LIQUIDACION!$D$9*(D121/366))*E121),-3))","v":0}]
[null,"Marzo","2016-03-31",{"v":0.2952,"d":"29.52%"},{"$f":"IF(C122<LIQUIDACION!$D$11,0,IF(C122>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E121)),(C122-LIQUIDACION!$D$11-SUM($E$3:E121))))","v":0},{"$f":"+IF(D122=\"\",0,ROUND(((LIQUIDACION!$D$9*(D122/366))*E122),-3))","v":0}]
[null,"Abril","2016-04-30",{"v":0.3081,"d":"30.81%"},{"$f":"IF(C123<LIQUIDACION!$D$11,0,IF(C123>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E122)),(C123-LIQUIDACION!$D$11-SUM($E$3:E122))))","v":0},{"$f":"+IF(D123=\"\",0,ROUND(((LIQUIDACION!$D$9*(D123/366))*E123),-3))","v":0}]
[null,"Mayo","2016-05-31",{"v":0.3081,"d":"30.81%"},{"$f":"IF(C124<LIQUIDACION!$D$11,0,IF(C124>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E123)),(C124-LIQUIDACION!$D$11-SUM($E$3:E123))))","v":0},{"$f":"+IF(D124=\"\",0,ROUND(((LIQUIDACION!$D$9*(D124/366))*E124),-3))","v":0}]
[null,"Junio","2016-06-30",{"v":0.3081,"d":"30.81%"},{"$f":"IF(C125<LIQUIDACION!$D$11,0,IF(C125>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E124)),(C125-LIQUIDACION!$D$11-SUM($E$3:E124))))","v":0},{"$f":"+IF(D125=\"\",0,ROUND(((LIQUIDACION!$D$9*(D125/366))*E125),-3))","v":0}]
[null,"Julio","2016-07-31",{"v":0.3201,"d":"32.01%"},{"$f":"IF(C126<LIQUIDACION!$D$11,0,IF(C126>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E125)),(C126-LIQUIDACION!$D$11-SUM($E$3:E125))))","v":0},{"$f":"+IF(D126=\"\",0,ROUND(((LIQUIDACION!$D$9*(D126/366))*E126),-3))","v":0}]
[null,"Agosto","2016-08-31",{"v":0.3201,"d":"32.01%"},{"$f":"IF(C127<LIQUIDACION!$D$11,0,IF(C127>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E126)),(C127-LIQUIDACION!$D$11-SUM($E$3:E126))))","v":0},{"$f":"+IF(D127=\"\",0,ROUND(((LIQUIDACION!$D$9*(D127/366))*E127),-3))","v":0}]
[null,"Septiembre","2016-09-30",{"v":0.3201,"d":"32.01%"},{"$f":"IF(C128<LIQUIDACION!$D$11,0,IF(C128>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E127)),(C128-LIQUIDACION!$D$11-SUM($E$3:E127))))","v":0},{"$f":"+IF(D128=\"\",0,ROUND(((LIQUIDACION!$D$9*(D128/366))*E128),-3))","v":0}]
[null,"Octubre","2016-10-31",{"v":0.3299,"d":"32.99%"},{"$f":"IF(C129<LIQUIDACION!$D$11,0,IF(C129>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E128)),(C129-LIQUIDACION!$D$11-SUM($E$3:E128))))","v":0},{"$f":"+IF(D129=\"\",0,ROUND(((LIQUIDACION!$D$9*(D129/366))*E129),-3))","v":0}]
[null,"Noviembre","2016-11-30",{"v":0.3299,"d":"32.99%"},{"$f":"IF(C130<LIQUIDACION!$D$11,0,IF(C130>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E129)),(C130-LIQUIDACION!$D$11-SUM($E$3:E129))))","v":0},{"$f":"+IF(D130=\"\",0,ROUND(((LIQUIDACION!$D$9*(D130/366))*E130),-3))","v":0}]
[null,"Diciembre","2016-12-31",{"v":0.3299,"d":"32.99%"},{"$f":"IF(C131<LIQUIDACION!$D$11,0,IF(C131>LIQUIDACION!$D$13,(LIQUIDACION!$D$13-LIQUIDACION!$D$11-SUM($E$3:E130)),(C131-LIQUIDACION!$D$11-SUM($E$3:E130))))","v":0},{"$f":"+IF(D131=\"\",0,ROUND(((LIQUIDACION!$D$9*(D131/366))*E131),-3))","v":0}]